sdk/samples/all in on code/Visual Studio 2010/VBASPNETAJAXWebChat/Data/SessionDB.dbml

   1 <?xml version="1.0" encoding="utf-8"?><Database Name="SessionDB" Class="SessionDBDataContext" xmlns="http://schemas.microsoft.com/linqtosql/dbml/2007">
   2   <Connection Mode="WebSettings" ConnectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\SessionDB.mdf;Integrated Security=True;User Instance=True" SettingsObjectName="System.Configuration.ConfigurationManager.ConnectionStrings" SettingsPropertyName="SessionDBConnectionString" Provider="System.Data.SqlClient" />
   3   <Table Name="dbo.tblChatRoom" Member="tblChatRooms">
   4     <Type Name="tblChatRoom">
   5       <Column Name="ChatRoomID" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
   6       <Column Name="ChatRoomPassword" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
   7       <Column Name="ChatRoomName" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
   8       <Column Name="NeedPassword" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
   9       <Column Name="MaxUserNumber" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
  10       <Column Name="IsLock" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
  11       <Association Name="tblChatRoom_tblTalker" Member="tblTalkers" ThisKey="ChatRoomID" OtherKey="ChatRoomID" Type="tblTalker" />
  12     </Type>
  13   </Table>
  14   <Table Name="dbo.tblTalker" Member="tblTalkers">
  15     <Type Name="tblTalker">
  16       <Column Name="TalkerID" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
  17       <Column Name="SessionID" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
  18       <Column Name="ChatRoomID" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
  19       <Column Name="CheckInTime" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
  20       <Column Name="CheckOutTime" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
  21       <Association Name="tblTalker_tblMessagePool" Member="tblMessagePools" ThisKey="TalkerID" OtherKey="talkerID" Type="tblMessagePool" />
  22       <Association Name="tblChatRoom_tblTalker" Member="tblChatRoom" ThisKey="ChatRoomID" OtherKey="ChatRoomID" Type="tblChatRoom" IsForeignKey="true" />
  23       <Association Name="tblSession_tblTalker" Member="tblSession" ThisKey="SessionID" OtherKey="UID" Type="tblSession" IsForeignKey="true" />
  24     </Type>
  25   </Table>
  26   <Table Name="dbo.tblMessagePool" Member="tblMessagePools">
  27     <Type Name="tblMessagePool">
  28       <Column Name="messageID" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
  29       <Column Name="message" Type="System.String" DbType="NVarChar(1000) NOT NULL" CanBeNull="false" />
  30       <Column Name="SendTime" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
  31       <Column Name="talkerID" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
  32       <Association Name="tblTalker_tblMessagePool" Member="tblTalker" ThisKey="talkerID" OtherKey="TalkerID" Type="tblTalker" IsForeignKey="true" />
  33     </Type>
  34   </Table>
  35   <Table Name="dbo.tblSession" Member="tblSessions">
  36     <Type Name="tblSession">
  37       <Column Name="UID" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
  38       <Column Name="SessionID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
  39       <Column Name="IP" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
  40       <Column Name="UserAlias" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
  41       <Association Name="tblSession_tblTalker" Member="tblTalkers" ThisKey="UID" OtherKey="SessionID" Type="tblTalker" />
  42     </Type>
  43   </Table>
  44 </Database>